Good day,
I have a dataset with a column of thousands of rows of invoice numbers.
Sometimes the invoice numbers appears once per row, sometimes multiple invoice numbers appear in one row (always in the same column).
I can only manage to extract the first instance of the invoice number in all cases.
Is there any way to do for the cases where they appear multiple times (beside manually)?
Thank you.
I have a dataset with a column of thousands of rows of invoice numbers.
Sometimes the invoice numbers appears once per row, sometimes multiple invoice numbers appear in one row (always in the same column).
I can only manage to extract the first instance of the invoice number in all cases.
Is there any way to do for the cases where they appear multiple times (beside manually)?
Thank you.
Sample Data.xlsx | |||
---|---|---|---|
A | |||
2 | (data is messy like this this) | ||
3 | Invoices | ||
4 | Inv. 1234, Inv. 12345 | ||
5 | Inv. 4569 | ||
6 | Inv 6467, Inv. 3835, Inv. 4786 | ||
7 | Inv.5672, Inv. 3199, Inv.41165 | ||
8 | |||
9 | |||
10 | (need to get like this) | ||
11 | Inv # | ||
12 | 1234 | ||
13 | 12345 | ||
14 | 4569 | ||
15 | 6467 | ||
16 | 3835 | ||
17 | 4786 | ||
18 | 5672 | ||
19 | 3199 | ||
20 | 41165 | ||
Sheet2 |