Jul 26 2022 02:05 PM
I have converted a large dataset from PDF to Excel. The data consists of vehicles and their attributes. I would like to transpose the data but to have each vehicle and their attributes individually transposed so as to make the date readily usable in the future. I would like to have the data in a format I can use to highlight the same attribute for all vehicles in a single row or column. I could individually copy and paste every single vehicle and their attributes but this is not an efficient solution. I would image I can transpose all of the vehicles using some kind of a numbered formula - as each vehicle is individually numbered, I could enter a formula transposing at each numbered row. Please help me to find a solution to this, I have read and searched for answers but I have not been able to find a solution.
Jul 31 2022 02:34 AM
Aug 02 2022 02:14 PM
Aug 07 2022 01:48 AM
Aug 17 2022 03:59 AM
@Faraz Shaikh I hope this is enough.