O
Oslopelle
hi!
I have this huge raw data file containing produt sales that, when
exported to excel comes out in two rows instead of one. The file gets
enormously difficult to work with.
A
B C
´D
Product 1
Value 1:1 Value1:2
Value 1:3 value 1:4
Value 1:5 Value 1:6
Value 1:7
Value 2:1 Value2:2
Value 2:3 value 2:4
Value 2:5 Value 2:6
Value 2:7
Product 2
Value 1:1 Value1:2
Value 1:3 value 1:4
Value 1:5 Value 1:6
Value 1:7
Value 2:1 Value2:2
Value 2:3 value 2:4
Value 2:5 Value 2:6
Value 2:7
values 5 are one of 3 values (kassa, ordre or resept) is there someone
that knows of code that will cut values 5-7 if values five contains
any of the above mentioned words, paste them in coloums e-g on the row
above (so that i get all values in a neat row) and delete the row
containing values 5-7?
Product names are always fat. Does anyone know of code that will
automaticly paste the productname after the values, so i get.
Value 1:1 Value1:2 Value 1:3 value 1:4 Value
1:5 Value 1:6 Value 1:7 Product name
?
I have this huge raw data file containing produt sales that, when
exported to excel comes out in two rows instead of one. The file gets
enormously difficult to work with.
A
B C
´D
Product 1
Value 1:1 Value1:2
Value 1:3 value 1:4
Value 1:5 Value 1:6
Value 1:7
Value 2:1 Value2:2
Value 2:3 value 2:4
Value 2:5 Value 2:6
Value 2:7
Product 2
Value 1:1 Value1:2
Value 1:3 value 1:4
Value 1:5 Value 1:6
Value 1:7
Value 2:1 Value2:2
Value 2:3 value 2:4
Value 2:5 Value 2:6
Value 2:7
values 5 are one of 3 values (kassa, ordre or resept) is there someone
that knows of code that will cut values 5-7 if values five contains
any of the above mentioned words, paste them in coloums e-g on the row
above (so that i get all values in a neat row) and delete the row
containing values 5-7?
Product names are always fat. Does anyone know of code that will
automaticly paste the productname after the values, so i get.
Value 1:1 Value1:2 Value 1:3 value 1:4 Value
1:5 Value 1:6 Value 1:7 Product name
?