nahaku
Board Regular
- Joined
- Mar 19, 2020
- Messages
- 106
- Office Version
- 365
- 2019
- Platform
- Windows
I have table in power query where are entries with address and how many boxes should be there. but I would like to transform it from 1 row for example of 24 boxes to 24 rows of same address with 1 box
to make it like this
Template.xlsx | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | Ref1 | Ref2 | Country Code | County | City | Address Line 2 | Address Line 1 | Postcode | Company | Warehouse Code | No. of Package | ||
2 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 23 | ||||
3 | asdq | aszcc | GB | West Midlands | Coventry | Coundon Wedge Drive | Plot 1, Lyons Park | CV5 9FA | Amazon Fulfillment Centre | BHX4 | 12 | ||
4 | zxcv | asdzx | GB | Amazon Way | KY11 8XT | Amazon Fulfillment Centre | EDI4 | 32 | |||||
Template Generator |
to make it like this
Template.xlsx | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | Ref1 | Ref2 | Country Code | County | City | Address Line 2 | Address Line 1 | Postcode | Company | Warehouse Code | No. of Package | ||
2 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
3 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
4 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
5 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
6 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
7 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
8 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
9 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
10 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
11 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
12 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
13 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
14 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
15 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
16 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
17 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
18 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
19 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
20 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
21 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
22 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
23 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
24 | scasc | zxczxc | GB | Northamptonshire | Royal Oak Way North | NN11 8QL | Amazon Fulfillment Centre | BHX3 | 1 | ||||
Sheet1 |