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>
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...