Jak przestawić kolumny tak, żeby pierwszą kolumną była data, a następnie obok produkt, opis, cena itp. Ciężko załączyć załącznik dlatego wklejam:
date | shipping_cost | discount | product_quantity 1 | product_code 1 | product_name 1 | product_price 1 | product_discount 1 | product_value 1 | product_quantity 2 | product_code 2 | product_name 2 | product_price 2 | product_discount 2 | product_value 2 | product_quantity 3 | product_code 3 | product_name 3 | product_price 3 | product_discount 3 | product_value 3 | product_quantity 4 | product_code 4 | product_name 4 | product_price 4 | product_discount 4 | product_value 4 | product_quantity 5 | product_code 5 | product_name 5 | product_price 5 | product_discount 5 | product_value 5 | product_quantity 6 | product_code 6 | product_name 6 | product_price 6 | product_discount 6 | product_value 6 | product_quantity 7 | product_code 7 | product_name 7 | product_price 7 | product_discount 7 | product_value 7 | product_quantity 8 | product_code 8 | product_name 8 | product_price 8 | product_discount 8 | product_value 8 | product_quantity 9 | product_code 9 | product_name 9 | product_price 9 | product_discount 9 | product_value 9 | product_quantity 10 | product_code 10 | product_name 10 | product_price 10 | product_discount 10 | product_value 10 | product_quantity 11 | product_code 11 | product_name 11 | product_price 11 | product_discount 11 | product_value 11 | product_quantity 12 | product_code 12 | product_name 12 | product_price 12 | product_discount 12 | product_value 12 | product_quantity 13 | product_code 13 | product_name 13 | product_price 13 | product_discount 13 | product_value 13 | product_quantity 14 | product_code 14 | product_name 14 | product_price 14 | product_discount 14 | product_value 14 | product_quantity 15 | product_code 15 | product_name 15 | product_price 15 | product_discount 15 | product_value 15 | product_quantity 16 | product_code 16 | product_name 16 | product_price 16 | product_discount 16 | product_value 16 | product_quantity 17 | product_code 17 | product_name 17 | product_price 17 | product_discount 17 | product_value 17 | product_quantity 18 | product_code 18 | product_name 18 | product_price 18 | product_discount 18 | product_value 18 | product_quantity 19 | product_code 19 | product_name 19 | product_price 19 | product_discount 19 | product_value 19 | product_quantity 20 | product_code 20 | product_name 20 | product_price 20 | product_discount 20 | product_value 20 | product_quantity 21 | product_code 21 | product_name 21 | product_price 21 | product_discount 21 | product_value 21 | product_quantity 22 | product_code 22 | product_name 22 | product_price 22 | product_discount 22 | product_value 22 | status | sum | payment_form | company | name | phone | address | city | postcode | country | order_id | |
16.09.2017 09:20 | 28.00 | 0 | 1 | a00001398OUT | Donica Rosalie Srebrna Lene Bjerre M | 69.00 | 0.0000 | 69 | 1 | A00001399 | Donica Rosalie Srebrna Lene Bjerre L | 139.00 | 0.0000 | 139 | przesyłka wysłana | 236.00 | Pobranie | Marzena Strzelecka Strzelecka | 507112661 | agnieszka1991.krall@gmail.com | Ul.Wojska Polskiego 22a | Łomża | 18-400 | Polska | 3053 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
16.09.2017 11:43 | 18.00 | 0 | 2 | LUC13 | Poduszka Donetta Silver 45x45cm | 89.00 | 0.0000 | 178 | 1 | Poduszka Monogram Navy -Silver 45x45cm | Poduszka Monogram Navy/Silver 45x45cm | 89.00 | 0.0000 | 89 | gotowe do wysłania | 285.00 | Przelew | EMILIA CHMIELEWSKA | 503124135 | ERMICH85@TLEN.PL | LIPSKA 18 | SIENNO | 27-350 | Polska | 3054 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
16.09.2017 20:42 | 0.00 | 0 | 1 | 5,91E+12 | Donica/Wazon Shimmer | 80.00 | 0.0000 | 80 | przesyłka wysłana | 80.00 | Gotówka | Beata Kierczak | 338109623 | dyplomacja@poczta.fm | Działkowa 6 | Kęty | 32-650 | Polska | 3055 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
17.09.2017 11:46 | 18.00 | 0 | 1 | LBJ473001009 | Scarpa Pojemnik Lene Bjerre biały | 119.00 | 0.0000 | 119 | 1 | LBJ473201009 | Scarpa Dozownik Lene Bjerre biały | 129.00 | 0.0000 | 129 | gotowe do wysłania | 266.00 | Przelew | Małgorzata Ossmann-Bitner Ossmann-Bitner | 603686461 | goobit@wp.pl | Koszalinska, 7 | Wrocław | 54-316 | Polska | 3056 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
17.09.2017 17:29 | 18.00 | 0 | 1 | LBJ360901615 | Notilde Donica Srebrna Lene Bjerre L | 139.00 | 0.0000 | 139 | 1 | 20.0_2017 | Bukiet Hortensji Pastelowy Fiolet 45cm | 79.00 | 0.0000 | 79 | złożone | 236.00 | Przelew | MAŁGORZATA WALCZAK-KOZIARA | 510072631 | MALGOSIA2722@WP.PL | LUBOCKA 7 | KRAKÓW | 31-766 | Polska | 3057 |