Formatting data

Other articles

• Data Formatting Guide: Automate repetitive tasks in Excel Power Query
• Data Formatting Guide: Tools and Resources
• Data Formatting Guide: The Basics
• Data Formatting Guide: Consolidating Duplicate Trial Balance Accounts
• Data Formatting Guide: Data Requirements
• Data Formatting Guide: Excel Quick Reference
• Data Formatting Guide: Flipping signs for a range of accounts or based on condition(s)
• Data Formatting Guide: Looking up and Retrieving Data from Another File
• Data Formatting Guide: Simple degrouping of multiple columns, fill in blank account numbers (common QuickBooks example)
• Data Formatting Guide: Ungrouping and Checking Imbalance
• Data Formatting Guide: Ungroup and split account numbers and descriptions
• Data Formatting Guide - Quickbooks Sub-Accounts
• Data Formatting Guide: Quickbooks Sub-Accounts separated by : (extracting the text after the last occurrence of a delimiter)
• Data formatting guide: Tudor
• Data formatting tips and tricks
• Best practices: Before submitting a data formatting request
• Best practices: Large files
• Common GDPdU data formatting steps
• Converting dates into the appropriate format
• Convert negative credit values into positives
• Converting Debit and Credit Columns to Numbers in Excel
• Converting Text Files (delimited or fixed width) to Excel
• Convert character delimited text files to Excel format
• Copying account and account description information in Excel
• Separating cell data in Excel
• The difference between a file that can be formatted and a file that can't
• Ungroup and split: Extract complex patterns
• See all 27 articles