Forum Discussion
Excel VBA to merge cell with different font style
Below is the excel data i have: (Table 1) - each Project has mutiple rows and merged together And i would like to make it like this: (Table 2) - Each project has their own row To u...
something similar, but my case have underline and strikethrough so it is more complicated
f01 f02
2 <u>Unexpected low load</u>
P-23066667:<s> Availability</s>
3 Unexpected low traffic
P-23066632: Availability
4 other
Yes, that is true.
If play with html ,tags u and s are available to render underline and strikethrough.
select f01,f02 from unmerge_cells limit 5;
create temp table aa as
select fillna(f01) f01,f02 from unmerge_cells;
drop table if exists split_to_multiple;
create table split_to_multiple as
select f01,group_concat(f02,'<br>') f02 from aa group by f01;
select * from split_to_multiple;