Does Calc has any feature similar to POWER QUERY in excel?

asked 2019-07-14 20:03:21 +0100

ANUP gravatar image

I send and request additional column(s) to be filled in a sheet from say 30 sales reps of my zone. Each sales rep has a unique identity no assigned to it and the sheet has columns like this: Sales Rep ID | Customer Name | Customer Account No | Sales item | Feedback Now all data other than last column (feedback) is already there when I send the file to these 30 reps These 30 reps will update Feedback column and send back the file. Now I need to update the data from these 30 files to my original file. How to do that without copying data from each file separately and updating it manually?

edit retag flag offensive close merge delete