ezpzspreadsheets
New Member
- Joined
- Dec 17, 2017
- Messages
- 2
I have an array of a sales report that was a .csv. I ran the text to columns and am left with this. I named the data set A2:F6 as "MYDATA"
<tbody>
</tbody>
I want the data to look like this
<tbody>
</tbody>
I've tried
INDEX(MyData,1+INT((ROW(A1)-1)/COLUMNS(MyData)),MOD(ROW(A1)-1+COLUMNS(MyData),COLUMNS(MyData))+1)
to get the ITEM in one column, but am not sure how to carry over the Header information (names) in column A. Thanks in advance.
A | B | C | D | E | F | |
1 | Name | Item | Item | Item | Item | Item |
2 | Jane | Shirt | Leggings | Dress | ||
3 | Sallie | Dress | ||||
4 | Edith | Leggings | Skirt | |||
5 | Cora | Leggings | ||||
6 | Sallie | Skirt | Dress | Dress | Leggings | Shirt |
<tbody>
</tbody>
I want the data to look like this
A | B | |
1 | Name | Item |
2 | Jane | Shirt |
3 | Jane | Leggings |
4 | Jane | Dress |
5 | Sallie | Dress |
6 | Edith | Leggings |
7 | Edith | Skirt |
8 | Cora | Leggings |
9 | Sallie | Skirt |
10 | Sallie | Dress |
11 | Sallie | Dress |
12 | Sallie | Leggings |
13 | Sallie | Shirt |
<tbody>
</tbody>
I've tried
INDEX(MyData,1+INT((ROW(A1)-1)/COLUMNS(MyData)),MOD(ROW(A1)-1+COLUMNS(MyData),COLUMNS(MyData))+1)
to get the ITEM in one column, but am not sure how to carry over the Header information (names) in column A. Thanks in advance.