Transpose values inside a single row into individual rows

**palmeirense_** · 10-13-2021, 09:12 AM

Hi,

Looking to transpose a few values that are inside a row and separated by commas into their own rows.
Attaching workbook here.

Thanks!

**Pete_UK** · 10-13-2021, 09:24 AM

Will you always have 3 items in column E?

Pete

**palmeirense_** · 10-13-2021, 09:25 AM

Not necessarily, it could be less or more

**Pete_UK** · 10-13-2021, 09:29 AM

OK. Will the items be longer than the single letters you have shown in the example?

Pete

**palmeirense_** · 10-13-2021, 09:33 AM

Yes, they are full product descriptions containing spaces. The formula should take all the words before each comma

**alansidman** · 10-13-2021, 11:53 AM

A couple of simple steps in Power Query
1. Load to PQ editor on the Data Tab-->Get and Transform-->from Range/Table
2. Highlight the columns not needed--->Remove Columns
3. Highlight comma separated data
4. Click on Split Data-->Select split to rows.

Here is the Mcode.

Please Login or Register  to view this content.

Transpose values inside a single row into individual rows

LinkBack

Thread Tools

Rate This Thread

Display

Transpose values inside a single row into individual rows

Re: Transpose values inside a single row into individual rows

Re: Transpose values inside a single row into individual rows

Re: Transpose values inside a single row into individual rows

Re: Transpose values inside a single row into individual rows

Re: Transpose values inside a single row into individual rows

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Transpose/Copy Individual Data of Rows into Merged Cells in Columns

[SOLVED] How to transpose a single column into individual rows based on a similar data?

[SOLVED] VBA To Transpose Values In Rows To Single Column

Transpose column data to individual rows, while repeating certain cells per row

convert rows of street addresses into individual columns (no transpose)

How can I change a list from a single cel to individual rows?

Transpose unique values in one column/mult. rows into a single row

Bookmarks

Bookmarks

Posting Permissions