Transform Data or Transpose

[murthysydney]

Hi All,

I am extracting the data from Web within the company, the data has tables in alternate rows as shown below.
I need to have the Table Column format and not in row format so i can expand and get the data.

Any help will be helpfull.
Thanks

 

[Matt Allington]

A General approach would be
create 3 more custom columns. They should just be duplicates of the current 3.
try to force an error on the table rows in the 3 columns. Maybe try changing data type to text. Assuming that works, replace errors in those 3 columns with nulls then fill those 3 columns down. This will put the 3 text columns along side the tables in the original columns. Then fitler in the original Options column and remove the text rows. From there it should be a matter of expanding the tables.

 

[murthysydney]

Hi All,

Tried as suggested but did not work..Is there any other solution.

Thanks