Forum Discussion

Lister1220's avatar
Lister1220
Copper Contributor
Sep 04, 2023

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...
Macros and VBA
  • Lister1220's avatar
    Lister1220
    Copper Contributor
    Sep 12, 2023
    something similar, but my case have underline and strikethrough so it is more complicated
    • peiyezhu's avatar
      peiyezhu
      Bronze Contributor
      Sep 12, 2023

       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;

       

       

Resources