✍️ CurePDF Blog

PDF Tips, Tutorials & Updates

Expert guides on working with PDFs, image editing tricks, and the latest from our team.

All Image Guides PDF Guides Spreadsheet & Data Guides Text & Developer Guides

📂 Spreadsheet-data-guides

1 post

Excel Pivot to Unpivot and Unpivot to Pivot: A Complete Guide

Wide tables are easy to read but hard to analyze. Learn how to unpivot Excel and CSV data into rows with Power Query, pivot it back into a summary, do the same in pandas with melt() and pivot(), and avoid the duplicates, blanks, and date problems that break the conversion.

Sep 30, 2026 · 18 min Read →