Placing Row Titles in Rows Below

lookout08

New Member
Joined
Sep 4, 2019
Messages
9
Good Afternoon All;

I am running into an issue I can't resolve with a data export. The data exports with what I suppose would be called a "Header" row, with the corresponding data in the rows beneath. There is no certain number of rows beneath, and due to the size of the file I can't do this manually. I am attempting to get all of the relevant data in a single row, but no solutions are coming to me. I have placed a crude example below (first post, still learning the example upload).

Current Situation:

Apples
John Smith / 5 Bushels / 7-5-2016

Needed Situation:

Apples/ John Smith / 5 Bushels / 7-5-2016

Anything you can think of would be a huge help; I've hit a complete wall on this one.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,573
Office Version
365
Platform
Windows
Whilst this is almost certainly do-able, we would need to see some accurate examples of exactly how your data is laid out.
 

lookout08

New Member
Joined
Sep 4, 2019
Messages
9
ABCDEFGHIJKLMNOPQRSTUVWX
1Header Row 1
2Row That Needs Headerxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
3Row That Needs Headerxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
4Header Row 2
5Row That Needs Headerxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
6Header Row 3
7Row That Needs Headerxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
Example listed above; please let me know if I can provide any additional information. Thank you so much for replying!
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,573
Office Version
365
Platform
Windows
How should that end up looking?
 

lookout08

New Member
Joined
Sep 4, 2019
Messages
9
Ideally the data in Row 1, Column A would be in a cell in rows 2 and 3; the data in Row 4, column A would be in a cell in row 5, and the data in row 6, column A would be in a cell in row 7
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,573
Office Version
365
Platform
Windows
Is column A blank other than the header rows?
 

lookout08

New Member
Joined
Sep 4, 2019
Messages
9
Yes, other than a small descriptor in that row that I will probably just remove using a "Find and Replace", the row is otherwise empty
 

lookout08

New Member
Joined
Sep 4, 2019
Messages
9
Correction: Row 1; column A does have data in the subsequent rows. The Rows with the header are blank, however, with the exception of the piece of data i'm moving.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,573
Office Version
365
Platform
Windows
So if column A has data, what do you want to do with that?
 

lookout08

New Member
Joined
Sep 4, 2019
Messages
9
I would need that moved to another cell (Maybe push the row one to the left and have the former header in the column A location, if possible)
 

Forum statistics

Threads
1,085,161
Messages
5,382,071
Members
401,768
Latest member
JAWHARRAH

Some videos you may like

This Week's Hot Topics

Top