Skip to main content
Web Applications

Return to Question

Bumped by Community user
edited tags. Edited for clarity.
Source Link
Blindspots ♦
Blindspots ♦
  • 7.5k
  • 5
  • 20
  • 38

Is there a cell formula or macro that I can use to reorganize data on subsequentfrom multiple rows and transpose it to subsequentinto multiple columns on the same row?

I haveam trying to manipulate data in a large spreadsheet (~1500~1,500 rows) that I am trying to manipulate the format of. I have created an example of what my data looks like and shown it here in the first image. I would like it to be organized like the table in the second picture.

Some invoice entries only have one WBS assigned to them, some have upwards of 8. 

If thean invoice has more than one WBS assigned to it, I would like to move it towant them all combined on the same row as the invoice, rather than the nexteach on a separate row as they are now.

In myI have an example picture below, cells E4 & F4 are to be moved of what my data looks like in the first image.

I would like it reorganized to G3 & H4match the second picture.

For example, in the first picture A3:F3 contains the first WBS entry for Supplier B, Invoice 2. The 2nd WBS for that invoice is in E4:F4 and cellsthe 3rd is in E5 & F5 are to be moved to I3 & J3:F5.

Any help would be greatly appreciatedIn the second image, all 3 of those WBS entries are combined on the same row in A3:F3.

enter image description hereoriginal data

enter image description heredesired result

Is there a cell formula or macro that I can use to reorganize data on subsequent rows and transpose it to subsequent columns?

I have a large spreadsheet (~1500 rows) that I am trying to manipulate the format of. I have created an example of what my data looks like and shown it here in the first image. I would like it to be organized like the table in the second picture.

Some invoice entries only have one WBS assigned to them, some have upwards of 8. If the invoice has more than one WBS assigned to it, I would like to move it to the same row as the invoice rather than the next row.

In my example picture below, cells E4 & F4 are to be moved to G3 & H4, and cells E5 & F5 are to be moved to I3 & J3.

Any help would be greatly appreciated.

enter image description here

enter image description here

Is there a formula that I can use to reorganize data from multiple rows into multiple columns on the same row?

I am trying to manipulate data in a large spreadsheet (~1,500 rows).

Some invoice entries only have one WBS assigned to them, some have upwards of 8. 

If an invoice has more than one WBS assigned to it, I want them all combined on the same row, rather than each on a separate row as they are now.

I have an example below of what my data looks like in the first image.

I would like it reorganized to match the second picture.

For example, in the first picture A3:F3 contains the first WBS entry for Supplier B, Invoice 2. The 2nd WBS for that invoice is in E4:F4 and the 3rd is in E5:F5.

In the second image, all 3 of those WBS entries are combined on the same row in A3:F3.

original data

desired result

edited tags
Link
Blindspots ♦
Blindspots ♦
  • 7.5k
  • 5
  • 20
  • 38
edited title
Link
reepjk23
reepjk23
  • 19
  • 2

Is there a cell formula or macro that I can use to simultaneously detect empty cells in a columnreorganize data on subsequent rows and then transpose datait to the end of a rowsubsequent columns?

deleted 3 characters in body
Source Link
reepjk23
reepjk23
  • 19
  • 2
Source Link
reepjk23
reepjk23
  • 19
  • 2