FG
💻 Software

Excel - pivot values in one cell (as comma-separated value)

Fresh7 days ago
Mar 15, 202643891 views
Confidence Score0%
0%

Problem

Excel - pivot values in one cell (as comma-separated value) I have two columns of data: I want to 'pivot' around Supplier, and give the list of products in one single cell, comma-separated e.g. There's about 1000 suppliers, and 0 < products <= 10. My current workaround involves using pivot tables, …

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Excel - pivot values in one cell (as comma-separated value)

Low Risk

Here's a non-VBA, non-pivot table solution that only uses a couple of formulas. First, I used the "Text-to-columns" to split your data at that "pipe" delimiter (the vertical line) into 2 columns; a "Supplier" column and a "Product" column. Those go …

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment