moonsketcher
New Member
- Joined
- Jun 7, 2016
- Messages
- 5
Hello
I have a long single column of data, that I need to transpose and have each new section separated onto a new row. (I realize that description is really confusing, I have included an example below)
<tbody>
</tbody>
And I'm trying to set a template so that the data (when pasted into the sheet) is auto formatted in a separate sheet to look like this:
<tbody>
</tbody>
Obviously, this is false data. The data I'm working with is sensitive so I can't paste it here.
I have the distinct feeling I am overthinking it, but after days of beating my head against the wall, I am finally giving in and asking for help. I have hunted all over the web and this site, but I think in the process of overthinking - that I am missing some key search phrase to have the magical answer handed to me.
The =Transpose function will not work because it requires extra key strokes. And no break for the next row.
I am making a simple template for EU to utilize to paste in data and have it automatically formatted accordingly.
Any help that anyone could offer would be greatly appreciated.
Please and thank you in advance.
I have a long single column of data, that I need to transpose and have each new section separated onto a new row. (I realize that description is really confusing, I have included an example below)
Data Type | Large Column of Data |
Name: | Mark |
Address: | 123 Roadname here |
City/State: | Columbus, Ohio |
Phone: | 555.555.5555 |
Name: | John |
Address: | 456 Roadtest Rd |
City/State: | San Diego, California |
Phone: | 555.555.5555 |
Name: | Tom |
Address: | 456 Testing Ct |
City/State: | Seattle, Washington |
Phone: | 555.555.5555 |
Name: | Bob |
Address: | 123 Excel Way |
City/State: | Castlerock, Maine |
Phone: | 555.555.5555 |
<tbody>
</tbody>
And I'm trying to set a template so that the data (when pasted into the sheet) is auto formatted in a separate sheet to look like this:
Name | Address | City/State | Phone |
Mark | 123 Roadname here | Columbus, Ohio | 555.555.5555 |
John | 456 Roadtest Rd | San Diego, California | 555.555.5555 |
Tom | 456 Testing Ct | Seattle, Washington | 555.555.5555 |
Bob | 123 Excel Way | Castlerock, Maine | 555.555.5555 |
<tbody>
</tbody>
Obviously, this is false data. The data I'm working with is sensitive so I can't paste it here.
I have the distinct feeling I am overthinking it, but after days of beating my head against the wall, I am finally giving in and asking for help. I have hunted all over the web and this site, but I think in the process of overthinking - that I am missing some key search phrase to have the magical answer handed to me.
The =Transpose function will not work because it requires extra key strokes. And no break for the next row.
I am making a simple template for EU to utilize to paste in data and have it automatically formatted accordingly.
Any help that anyone could offer would be greatly appreciated.
Please and thank you in advance.