This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have already thought of that solution, but this is just the sample data, I have about 85 columns coming in from both the files, I cannot create 85 formulas.. So, I am looking for some more dynamic solution.
Sorry, I should have mentioned that in my post before.
I did the transpose logic, which brought me all the columns into one single column "Name" and Values of them are stored in "Value" column. But my data is huge, its having about 118 columns which about 400K rows. I just did a sample test for 10k rows and it took like 15 mins to process them. I don't want to image how much time would it take if I process all the records in one go. Is there a better solution to this?