Moving multiple columns (8 x sets of 3) with data in separate rows into 3 columns

Hello
I have data that are in multiple columns in 8 sets of 3 columns, with data in separate rows. I would like to combine the columns, so I end up with 3 columns. All of the headings are different except, the first of a set always contains "Body", the second "Feet", the third "Head". How do I combine the columns?

Probably you could use some combination of OFFSET, MOD and ROW functions, but if you fail with your tries, consider attaching a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Hi,

You can use this formula to add all *_Body columns.

Formula:

Please Login or Register  to view this content.

Likewise for *Feet and *Head.

Hoop this helps,

Hi,

This is how i suggested it with my formula.

try for instance in N2:

Formula:

Please Login or Register  to view this content.

other option (if headers follow some rules) (headers in columns B:M start with texts from one of columns N:P

Formula:

Please Login or Register  to view this content.

and copy down/right

Another way using INDEX / MATCH. Array enter this in N2 fill down and across.

Formula:

Please Login or Register  to view this content.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

You're welcome. Thanks for the feedback and rep.