Hello - Long time stalker, first time poster. I've got an issue concerning over 30,000 items that I can't research and figure out simply because I can't explain it.

I need to convert this:

A B C D E F G H I J K
1 SKU ITEM1 QTY1 ITEM2 QTY2 ITEM3 QTY3 ITEM4 QTY4 ITEM5 QTY5
2 01CNBP208B1B1 BTCNBP208D01 1
3 01CNBP208B2B1 BTCNBP208D01 2
4 01CNBP208B3B1 BTCNBP208D01 3
5 01CNBP208B4B1 BTCNBP208D01 4
6 01CNBP208BC1B1 BTCNBP208D01 1 CHCNBP208D01 1
7 01CNBP208BC2B1 BTCNBP208D01 2 CHCNBP208D01 1
8 01CNBP208KB1B1 BTCNBP208D01 1 LCK5 1 MEMCASE 1 CRSD 1
9 01CNBP208KB2B1 BTCNBP208D01 2 LCK5 1 MEMCASE 1 CRSD 1
10 01CNBP208KB3B1 BTCNBP208D01 3 LCK5 1 MEMCASE 1 CRSD 1
11 01CNBP208KB4B1 BTCNBP208D01 4 LCK5 1 MEMCASE 1 CRSD 1
12 01CNBP208KBC1B1 BTCNBP208D01 1 CHCNBP208D01 1 LCK5 1 MEMCASE 1 CRSD 1
13 01CNBP208KBC2B1 BTCNBP208D01 2 CHCNBP208D01 1 LCK5 1 MEMCASE 1 CRSD 1
14 01CNBP208KBC3B1 BTCNBP208D01 3 CHCNBP208D01 1 LCK5 1 MEMCASE 1 CRSD 1

Into this:
A B C
1 SKU ITEM QTY
2 01CNBP208B1B1 BTCNBP208D01 1
3 01CNBP208B2B1 BTCNBP208D01 2
4 01CNBP208B3B1 BTCNBP208D01 3
5 01CNBP208B4B1 BTCNBP208D01 4
6 01CNBP208BC1B1 BTCNBP208D01 1
7 01CNBP208BC1B1 CHCNBP208D01 1
8 01CNBP208BC2B1 BTCNBP208D01 2
9 01CNBP208BC2B1 CHCNBP208D01 1
10 01CNBP208BC3B1 BTCNBP208D01 3
11 01CNBP208BC3B1 CHCNBP208D01 1
12 01CNBP208BC4B1 BTCNBP208D01 4
13 01CNBP208BC4B1 CHCNBP208D01 1
14 01CNBP208C1B1 CHCNBP208D01 1
151 01CNBP208KB1B1 BTCNBP208D01 1
16 01CNBP208KB1B1 LCK5 1
17 01CNBP208KB1B1 MEMCASE 1
18 01CNBP208KB1B1 CRSD 1
19 01CNBP208KB2B1 BTCNBP208D01 2
20 01CNBP208KB2B1 LCK5 1
21 01CNBP208KB2B1 MEMCASE 1
22 01CNBP208KB2B1 CRSD 1

Can anyone help me out? Would save me endless frustration