Converting Multiple columns to rows

[mramda]

Hi I have looked and cannot find a solution, I hope you can help, I have a spreadsheet with variable multiple columns, the column goes all the way to Cells "IV"



Data looks like this

TextA TextB TextC TextD TextE TextF
TextA TextB TextC TextD TextE TextF TextG TextH TextI TextJ TextK TextL TextM TextN
TextA TextB TextC TextD TextE TextF TextC TextD TextE TextF
TextA TextB TextC TextD TextE TextF TextG TextH TextI TextJ TextK TextL TextM TextN TextA TextB TextC TextD TextE TextF TextG TextH


I need a table with 6 columns see below, the first 2 columns remains con
TextA TextB TextC TextD TextE TextF
TextA TextB TextC TextD TextE TextF
TextA TextB TextC TextD TextE TextF

I have attached a sample workbook

The sheet contains 2000 + rows and I am hoping for a solution and not have to do this manually.

[JieJenn]

Try

Please Login or Register  to view this content.

[mramda]

Hi JieJenn,this works for the sample data however If I add another row, it mixes up the data, is it possible to copy the first 2 columns also, this will make the data set complete, thanks very much, for the quick responce

[JieJenn]

Can you attach an updated sample workbook?

[mramda]

Hello, I have attached an updated workbook, many thanks again for the assistance.