Forum Discussion
Grouped text conversion to columns in Excel
- Someone was able to use IF, sumifs formulas & pivot tables to convert the data for me. I appreciate your reply!
Possibly.
Much will depend on the level of consistency of how the data are organized.
Your description doesn't give enough details, however. Is it possible to post a few representative sets of the textual data, after first changing any personal data so that no real person can be identified.
mathetes Thank you for your reply! I have attached sample data showing how it pulled as txt. I need to separate into columns, i.e. A=Employee, B=REG, C=OT, etc. for all possible row labels
My, oh, my, what a mess. I'm retired now, but had a long career in HR, and for some of that time was director of the HR and Payroll database for a major corporation. So I recognize these fields.
Just out of curiosity, is it possible to go back to the source of that text file--which pretty obviously was a database of some kind--and get it delivered as a CSV file (as it should have been in the first place)?
I'm sure it would be possible to write some kind of routine that could go through this text file and parse it into its many fields, but there's not a consistent set of columns (it's finite, but varies from person to person).......so it would be a stripping routine that would be beyond my abilities.
