Hello, I have to use only excel or its plugins to do this as my boss wants me to automate this process for lazy people who are not advance computer useres.
I have been trying to get a custom report for which I have a table and a query that fileters the data for me.
I have six columns (Machine type, machine description, base warranty, 1 year service, 2 year service, 3 year service)
There are 3 records(rows) having the same same value for Machine type "4400", machine description "Big machine", base warranty "1".
Now the 1st row has a serial number under 1 year service and no values for the rest of the remaining columns.
2nd row has a serial number under 2 year service and no values for the rest of the remaining columns.
3rd row has a serial number under the 3 year service and no values for the remaing columns.
How to automate this that I get one single row so that I avoide dublicates in first 3 columns and the years serial number come on seperate columns givin me 1row
2007-02-07
01:01:55
·
5 answers
·
asked by
Sib
2