Transferring Data from one sized grid to another sized destination

dzufelt · Apr 25th 2022

Hello,

I need to copy data from a 11 x 15 cell grid and insert it into another sheet in a 1 X 165 cell grid format (one row).

Any suggestions are greatly appreciated! Thank you!!

**royUK** · Apr 26th 2022

Exactly what do you mean. The smaller area will copy to the same sized area within the second grid.

dzufelt · Apr 26th 2022

I have an 11 X 15 grid of data that I need to paste into the new sheet in one continuous row, 165 cells long.

Here's a smaller example. If I had data in Cell A1, A2, B1, and B2 - I would need to paste it into a new sheet, but into A1, A2, A3 and A4.

Does that help?

**royUK** · Apr 27th 2022

Why is the original data in that format?

Marius44 · Apr 27th 2022

Hello

If I understand correctly I believe that the use of VBA is necessary.

A double loop to scan the cells of the first table and a counter to increment the target column.

Hello,

Mario

dzufelt · May 2nd 2022

The original data is being exported from a system in the format.

Thank you! I will look into the VBA solution.

**royUK** · May 3rd 2022

Provide an example workbook with showing what you want to achieve.

dzufelt · May 3rd 2022

I was able to find a formula that worked - in case anyone else ever has this need.

The 11X15 grid started in cell A1 of Sheet 1. On Sheet 2, I put this formula in cell A1 and dragged to the right until cell FI1

=OFFSET(Sheet1!$A$1,((ROW()-1)*E75)+(FLOOR(COLUMN()-1,15)/15),(COLUMN()-1)-(FLOOR(COLUMN()-1,15)))

Participate now!