Spreadsheet: 889710d1740609077-offset-formula-offset-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  | TABLE
 |  |  |  |  |  |  |  | Product | Customer Number | Spend Type | Sale Amount | Invoice Number | Invoice Parent
 |  |  |  |  |  |  |  | Apple | CUS41780 | GUT | 560 | INV8888418 | PAR7552
 | Copy rows 13:17 and paste in a multiple of 5 rows….. |  |  |  |  |  |  | Orange | CUS32601 | PRO | 986 | INV8740274 | PAR6383
 |  |  |  |  |  |  |  | Apple | CUS58733 | GUT | 9933 | INV2051478 | PAR426
 |  |  |  |  |  |  |  | [NAME] | CUS75749 | PRO | 3355 | INV9921991 | PAR5015
 |  |  |  |  |  |  |  | Orange | CUS99951 | GUT | 2323 | INV5748341 | PAR1716
 |  |  |  |  |  |  |  | Kiwi | CUS86876 | PRO | 12 | INV4297610 | PAR2565
 |  |  |  |  |  |  |  | Orange | CUS7416 | INC | 4200 | INV2536817 | [NAME]
 |  |  |  |  |  |  |  | Imagine 1,000 rows of this
OFFSET to this format. Copy 1,000+ times down
Customer Number | Spend Type | Country Code | Sale Amount | Invoice Number | Invoice Parent | Invoice Reference
 |  | US
Product | UOM | Currency | Plan Type | Invoice Number
 | EA | USD
$$$
Customer Number | Spend Type | Country Code | Sale Amount | Invoice Number | Invoice Parent | Invoice Reference
 |  | US
Product | UOM | Currency | Plan Type | Invoice Number
 | EA | USD
$$$
Customer Number | Spend Type | Country Code | Sale Amount | Invoice Number | Invoice Parent | Invoice Reference
 |  | US
Product | UOM | Currency | Plan Type | Invoice Number
 | EA | USD
$$$
Customer Number | Spend Type | Country Code | Sale Amount | Invoice Number | Invoice Parent | Invoice Reference
 |  | US
Product | UOM | Currency | Plan Type | Invoice Number
 | EA | USD
$$$
Customer Number | Spend Type | Country Code | Sale Amount | Invoice Number | Invoice Parent | Invoice Reference
 |  | US
Product | UOM | Currency | Plan Type | Invoice Number
 | EA | USD
$$$
Customer Number | Spend Type | Country Code | Sale Amount | Invoice Number | Invoice Parent | Invoice Reference
 |  | US
Product | UOM | Currency | Plan Type | Invoice Number
 | EA | USD
$$$
Customer Number | Spend Type | Country Code | Sale Amount | Invoice Number | Invoice Parent | Invoice Reference
 |  | US
Product | UOM | Currency | Plan Type | Invoice Number
 | EA | USD
$$$
Customer Number | Spend Type | Country Code | Sale Amount | Invoice Number | Invoice Parent | Invoice Reference
 |  | US
Product | UOM | Currency | Plan Type | Invoice Number
 | EA | USD
$$$
Customer Number | Spend Type | Country Code | Sale Amount | Invoice Number | Invoice Parent | Invoice Reference
 |  | US
Product | UOM | Currency | Plan Type | Invoice Number
 | EA | USD
$$$
Customer Number | Spend Type | Country Code | Sale Amount | Invoice Number | Invoice Parent | Invoice Reference
 |  | US
Product | UOM | Currency | Plan Type | Invoice Number
 | EA | USD
$$$
Customer Number | Spend Type | Country Code | Sale Amount | Invoice Number | Invoice Parent | Invoice Reference
 |  | US
Product | UOM | Currency | Plan Type | Invoice Number
 | EA | USD
$$$
Customer Number | Spend Type | Country Code | Sale Amount | Invoice Number | Invoice Parent | Invoice Reference
 |  | US
Product | UOM | Currency | Plan Type | Invoice Number
 | EA | USD
$$$
Customer Number | Spend Type | Country Code | Sale Amount | Invoice Number | Invoice Parent | Invoice Reference
 |  | US
Product | UOM | Currency | Plan Type | Invoice Number
 | EA | USD
$$$
Customer Number | Spend Type | Country Code | Sale Amount | Invoice Number | Invoice Parent | Invoice Reference
 |  | US
Product | UOM | Currency | Plan Type | Invoice Number
 | EA | USD
$$$
Customer Number | Spend Type | Country Code | Sale Amount | Invoice Number | Invoice Parent | Invoice Reference
 |  | US
Product | UOM | Currency | Plan Type | Invoice Number
 | EA | USD
$$$
Customer Number | Spend Type | Country Code | Sale Amount | Invoice Number | Invoice Parent | Invoice Reference
 |  | US
Product | UOM | Currency | Plan Type | Invoice Number
 | EA | USD
$$$
Customer Number | Spend Type | Country Code | Sale Amount | Invoice Number | Invoice Parent | Invoice Reference
 |  | US
Product | UOM | Currency | Plan Type | Invoice Number
 | EA | USD
$$$
Customer Number | Spend Type | Country Code | Sale Amount | Invoice Number | Invoice Parent | Invoice Reference
 |  | US
Product | UOM | Currency | Plan Type | Invoice Number
 | EA | USD
$$$
Customer Number | Spend Type | Country Code | Sale Amount | Invoice Number | Invoice Parent | Invoice Reference
 |  | US
Product | UOM | Currency | Plan Type | Invoice Number
 | EA | USD
$$$