Forum Discussion
Formulas for Multiple Conditions and Formatting
I have a very large amount of data (30,000 lines) in Excel that contains multiple extra spaces between lines and was created with reference fields on both the top and left side. There also isn't the ...
mathetes
Thank you very much for your feedback. Unfortunately, this is the only data provided to me. I requested a more "raw" form of the data; but I'm currently on the IT department's backlog. I was looking for a way to simplify this information in order to proceed with my assigned task while I await IT.
Thank you very much for your feedback. Unfortunately, this is the only data provided to me. I requested a more "raw" form of the data; but I'm currently on the IT department's backlog. I was looking for a way to simplify this information in order to proceed with my assigned task while I await IT.
sunderdown That would be something for PowerQuery. Can you share a sample of the data as you receive it an explain how to interpret it? The screen shot doesn't clarify much. At least, not for me.
Use Onedrive, Google docs, Dropbox or something similar to share a file.