SOLVED

Formatting help with Transpose

Copper Contributor

Hi everyone,

I am trying to split the Standard released column in such a way after the semicolon it should in the next row. Please see attached excel sheet

 

Input 

sbhan4_0-1602526438909.png

 

Output

sbhan4_1-1602526796646.png

 

4 Replies
best response confirmed by sbhan4 (Copper Contributor)
Solution

@sbhan4 

easiest way is with Power Query

- convert the source to table or name it as Range and query

- split first column texts to list with semicolon delimiters

- expand lists to rows

- load result to Excel sheet

image.png

@Sergei Baklan 

 

Thanks for your help!

 

I am using a power query.

 

-splitting columns by delimiter - done

- How to expand lists to rows?

@Sergei Baklan It worked perfectly!! thanks !!!

@Sergei Baklan It worked ..thanks

1 best response

Accepted Solutions
best response confirmed by sbhan4 (Copper Contributor)
Solution

@sbhan4 

easiest way is with Power Query

- convert the source to table or name it as Range and query

- split first column texts to list with semicolon delimiters

- expand lists to rows

- load result to Excel sheet

image.png

View solution in original post