Forum Discussion
How to pivot (or sort) data into four columns with headers from a column with 4 repeating values.
Hello community, I spent a month on the intermediate to advanced tutorials and have been lurking in the forums for a couple weeks and cannot find the answer after fiddling around. Data is par...
This is very difficult problem to solve but seems like something one should be able to do. I am transforming from a sample sheet (text) file as I am using "get data" to pull in a folder.
1. I was able to filter the data, create 4 different tables for the Date, From, To, and Totals Seconds column. I merged queries to put the different table data back in to a master table but there are no values as it just says "table, table, table" in the cells. How do I get real data and where did I go wrong?
2. The relationships in the model tab/page appear broken with the space between & 2 parenthesis on the "relationship line"
Can someone help or is there a better way when mining from full txt files (all using the same format) to use the data?