MarkJamesDavies
New Member
- Joined
- Jan 30, 2015
- Messages
- 12
Hello,
This is my first post, please be patient. I will put as much detail as possible.
I'm trying to export all of the data between headers from a pivot table into 1 cell but the items in between are inconsistent in terms of their cell creation. I tried the "=CONCATENATE" function however, due to the cells being inconsistent, it's very difficult to do.
Is it possible someone could help me with this problem? I visit this site a lot and has been wonderful.
Table Example (imagine this table in a 1 column pivot table with the numbers in a header):
<colgroup><col></colgroup><tbody>
</tbody>
<colgroup><col></colgroup><tbody>
</tbody>
This is my first post, please be patient. I will put as much detail as possible.
I'm trying to export all of the data between headers from a pivot table into 1 cell but the items in between are inconsistent in terms of their cell creation. I tried the "=CONCATENATE" function however, due to the cells being inconsistent, it's very difficult to do.
Is it possible someone could help me with this problem? I visit this site a lot and has been wonderful.
Table Example (imagine this table in a 1 column pivot table with the numbers in a header):
464654727 |
dress |
464654728 |
hat |
leggings |
shirt |
shoes |
tie |
464654729 |
boots |
dress |
shirt |
464654730 |
shoes |
tie |
464654731 |
leggings |
464654732 |
boots |
dress |
hat |
shirt |
464654733 |
shoes |
464654734 |
tie |
464654735 |
boots |
dress |
hat |
leggings |
shirt |
shoes |
tie |
464654736 |
boots |
464654737 |
dress |
464654738 |
shirt |
464654739 |
shoes |
464654740 |
leggings |
<colgroup><col></colgroup><tbody>
</tbody>
Thanks in advance for any help. MJD |
<colgroup><col></colgroup><tbody>
</tbody>